<?php
class retrieve_micromenu_admin extends retrieve_base{

	private $module_display_options 	= array(
		array("MICROMENU_DISPLAY", "MICROMENU_DISPLAY_CHANNEL")
	);

		/**
	* function produces abstract structure of modules db structure
	*
    * used to generate the table structure required abstract function that passes an abstract
	* representation of the desired table structure to the proper database module which will
	* interpet the abstract and convert it into a valid SQL Create table structure.
	*
	* @return Array list of abstract table definitions for this module
	*/
	function create_table(){
		$tables = array();
		/**
		* Table structure for table 'micromenu_list'
		*/
		$fields = array(
			array("micromenu_identifier"		,"unsigned integer"			,"NOT NULL"	,"auto_increment","key"),
			array("micromenu_client"			,"unsigned integer"			,"NOT NULL"	,"default '0'","key"),
			array("micromenu_label"				,"varchar(255)"				,"NOT NULL"	,"default ''"),
			array("micromenu_creation_date"		,"datetime"					,"NOT NULL"	,"default '0000-00-00 00:00:00'"),
			array("micromenu_status"			,"unsigned integer"			,"NOT NULL"	,"default '0'"),
			array("micromenu_display_type"		,"unsigned integer"			,"NOT NULL"	,"default '0'"),
			array("micromenu_extract_type"		,"unsigned integer"			,"NOT NULL"	,"default '0'"),
			array("micromenu_all_locations"		,"unsigned integer"			,"NOT NULL"	,"default '0'"),
			array("micromenu_set_inheritance"	,"unsigned integer"			,"NOT NULL"	,"default '0'"),
			array("micromenu_show_label"		,"unsigned small integer"	,"NOT NULL"	,"default '1'"),
			array("micromenu_parent"			,"signed integer"			,"NOT NULL"	,"default '-1'"),
			array("micromenu_show_type"			,"unsigned small integer"	,"NOT NULL"	,"default '0'")
			
		);
		$primary ="micromenu_identifier";
		$tables[count($tables)] = array("micromenu_list", $fields, $primary);
		/**
		* Table structure for table 'micromenu_url'
		*/
		$fields = array(
			array("mmur_identifier"		,"unsigned integer"			,"NOT NULL"	,"auto_increment","key"),
			array("mmur_client"			,"unsigned integer"			,"NOT NULL"	,"default '0'","key"),
			array("mmur_micro"			,"unsigned integer"			,"NOT NULL"	,"default '0'","key"),
			array("mmur_title"			,"varchar(255)"				,"NOT NULL"	,"default ''"),
			array("mmur_label"			,"varchar(255)"				,"NOT NULL"	,"default ''"),
			array("mmur_rank"			,"unsigned integer"			,"NOT NULL"	,"default '0'"),
			array("mmur_datecreated"	,"datetime"					,"NOT NULL"	,"default '0000-00-00 00:00:00'")
		);
		$primary ="mmur_identifier";
		$tables[count($tables)] = array("micromenu_definition", $fields, $primary);
		return $tables;
	}
}
?>